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