UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dVYLSJydrx7QnKe3KYvorFTW6TPHxlTlx7kKm9Hw0a4='
WHERE
key_id = '78ddfcb2b815586ac90a1242b4354190f75b74bb4d01526738a305a4feea96bb'
AND (
token = 'dVYLSJydrx7QnKe3KYvorFTW6TPHxlTlx7kKm9Hw0a4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)