UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mckFU9mm1m5vmXf+m5zUJxjiy9nO5d9tO6hLg1qQ++w='
WHERE
key_id = 'f4547bcf75112c3f2741a6266859260acb643765f93b3b62d64cc77a2a98157a'
AND (
token = 'mckFU9mm1m5vmXf+m5zUJxjiy9nO5d9tO6hLg1qQ++w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)