UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SieoayM7iplueNkTQsdfr8wm3j3zJcZisvJHW4F7Tuk='
WHERE
key_id = '47676e13b7928e9bc7addc55c1496eae3262940b1ca1cc99bdae96492293a90d'
AND (
token = 'SieoayM7iplueNkTQsdfr8wm3j3zJcZisvJHW4F7Tuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)