UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PPr1gySgwgoyGtTnTfb/9OVOFAvbpFiAJuoU31gK4ns='
WHERE
key_id = '296de8415139dd2bd8918467a0df95c1e3940592585e6be526c9d29101f664d6'
AND (
token = 'PPr1gySgwgoyGtTnTfb/9OVOFAvbpFiAJuoU31gK4ns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)