UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hzyd1e1WS3joWyZQqhfE4ypI3HWXPAkKIzR5AfXYwyI='
WHERE
key_id = '0224b016ba45dd6a89ec2ce26a2434f85d46c4434cd3cd18a328688897a54283'
AND (
token = 'hzyd1e1WS3joWyZQqhfE4ypI3HWXPAkKIzR5AfXYwyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)