UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FdR3j/w4nns5jzgB3K7Cmle7JPxZmV7DwunwMQQe6XY=' 
WHERE 
  key_id = '0a32949f6f337530e7339b508ad0ae52ee996ca0aa54585cc20e1aa14a8e69e4' 
  AND (
    token = 'FdR3j/w4nns5jzgB3K7Cmle7JPxZmV7DwunwMQQe6XY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029