UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm9uZ78pN+VwgGJQqsCQvmpF4L6heoCLUU+J+4r/ilow='
WHERE
key_id = '0be28a1356eb78da42d3466397e110a48badb2eb1eeae23037150a92b236ce1a'
AND (
token = 'm9uZ78pN+VwgGJQqsCQvmpF4L6heoCLUU+J+4r/ilow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)