UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9yCXUKY3wffCaU3G97u0YHZyb1leyU3dj6cm5Imssws='
WHERE
key_id = '79918a2b196594b6214e182fa764556d7dd9a918ce34463c271d2a3821000c5d'
AND (
token = '9yCXUKY3wffCaU3G97u0YHZyb1leyU3dj6cm5Imssws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)