UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MXodBH5CUJMyrnFpJfhpLR7ghmsvnK2Q0g1GR05evEk='
WHERE
key_id = 'a9c7479f67087d795b4ae069cedd0a4a48a3736be6bd920c04289cb846f629a3'
AND (
token = 'MXodBH5CUJMyrnFpJfhpLR7ghmsvnK2Q0g1GR05evEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)