UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sVlHo5Fv267RAE2+GySIjUY4hUgzzdSoZ7VLCH36L9A='
WHERE
key_id = '2d2e71127c8e4337d5fd49f3608ec2a30420daaec456ce23e11ed0b55f7315e4'
AND (
token = 'sVlHo5Fv267RAE2+GySIjUY4hUgzzdSoZ7VLCH36L9A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)