UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+nlNtsIbw095GkWYP5MWzx0ny+1iKnkVcaW2Jn7rVrU='
WHERE
key_id = 'ce6fa86ea1b76852edc6419d25a53d988abf4273bdb66dcedfd9207798aef9f1'
AND (
token = '+nlNtsIbw095GkWYP5MWzx0ny+1iKnkVcaW2Jn7rVrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)