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