UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hx9BHPfoTQZ5iQykREZ8FOzCozrgwPi2TEOX893bQnA='
WHERE
key_id = '3a38986aed725293bb02e833613418a0f303d1ea95711dc599de8b740769e9fa'
AND (
token = 'hx9BHPfoTQZ5iQykREZ8FOzCozrgwPi2TEOX893bQnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)