UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49b/GGnQgVTZkl2236MEklZLw4dGm5WRc0WqZ7eCJvI='
WHERE
key_id = '5a7657b420296121abee23aba08c9b67be93b0922eea70c0d5a089de31b92b4e'
AND (
token = '49b/GGnQgVTZkl2236MEklZLw4dGm5WRc0WqZ7eCJvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)