UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+FqSABmUousz6MN8hXToareK72oFrf4QE51cKlfaknA=' 
WHERE 
  key_id = '54d51b7a8437130af6725ca907a6c6e72abadd2fd9a1d552ed59a3d5061a49d6' 
  AND (
    token = '+FqSABmUousz6MN8hXToareK72oFrf4QE51cKlfaknA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019