UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ntGPJyOWAin97NlNpdkjoi9Cbpklcvy9PQIGgQHper4='
WHERE
key_id = 'e3c1bfc7c5b78419868c743c4d159d910b78e6575a1e9cecd915fa7de822211d'
AND (
token = 'ntGPJyOWAin97NlNpdkjoi9Cbpklcvy9PQIGgQHper4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)