UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GlYzm2RyIrIwaLwAGdYQxDsDpgRJ3gkX9BVX2rF1srk='
WHERE
key_id = '78059e79bf1c8ccb009601b3642bfd93bf903619a3c09204d85c9e711a73c404'
AND (
token = 'GlYzm2RyIrIwaLwAGdYQxDsDpgRJ3gkX9BVX2rF1srk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)