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