UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bXUWaTAMbqv2RihwWQ+SFy7b3ukYuApJpsBEVdY4/CA='
WHERE
key_id = 'c3023225e87fb8dcf8127646145df7927897681280527516a963c2159273a63a'
AND (
token = 'bXUWaTAMbqv2RihwWQ+SFy7b3ukYuApJpsBEVdY4/CA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)