UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '534BKfc4lnkEzUrKBmZ4hVXUrVs7dC07VE0gnB4YfvM='
WHERE
key_id = 'd7f64e0e1cfb41943f1022810916669e94b706920b518bdd3c60d0ca8cc34ec7'
AND (
token = '534BKfc4lnkEzUrKBmZ4hVXUrVs7dC07VE0gnB4YfvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)