UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bad7WhoFX6wH+ygHLyvl9hbXAoqOLqeom4OT+GGclCg='
WHERE
key_id = '0e8784ecb3c3a59d48e2a5bf93eba212eda6f14d87ab1d2d1b07d309f9aee61b'
AND (
token = 'bad7WhoFX6wH+ygHLyvl9hbXAoqOLqeom4OT+GGclCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)