UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hB1Qb6syz3sGCMHzGYpMX+IfkbKVDVbtKn8hQWoHYE='
WHERE
key_id = 'c314a92a23c8a7f98e187e07e1b1673646d217a45bd25b5b6a2c457563ffc2a0'
AND (
token = '9hB1Qb6syz3sGCMHzGYpMX+IfkbKVDVbtKn8hQWoHYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)