UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+76uE2Rlb2io/FKtIpj0iYwHNZTbK5aP1Nr0/3kqf5s=' 
WHERE 
  key_id = 'bd5ec2a70e2a0cc0fc061645a6987c313c4ebd35e594e759c832e45817c1c18d' 
  AND (
    token = '+76uE2Rlb2io/FKtIpj0iYwHNZTbK5aP1Nr0/3kqf5s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024