UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E37+GYn2MKhY8/W7Pinu34DEo29KUIrPFt3JB+hMvqo='
WHERE
key_id = 'ca7d33877b2ce2dbad8cdbc493170702fcb38f14805b28ea27e125e57a809c92'
AND (
token = 'E37+GYn2MKhY8/W7Pinu34DEo29KUIrPFt3JB+hMvqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)