UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9bKMVdi8rG32DJzuxjAvwC3vAzEnWXzKmY3WeXcy6Q='
WHERE
key_id = '6790286a6d4ee6ab88d15f9b999592032b9e3f944c7580f4cff1314ad9256902'
AND (
token = 'N9bKMVdi8rG32DJzuxjAvwC3vAzEnWXzKmY3WeXcy6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)