UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sOj3MYSIFNfS7/KmLqMdP80+G2Q2XJQ/Y0mgAOcdvZ4=' 
WHERE 
  key_id = '47399fffb7b7c21abc7460dcfdb312cc7d705104272293fc70fc8214c5cd9338' 
  AND (
    token = 'sOj3MYSIFNfS7/KmLqMdP80+G2Q2XJQ/Y0mgAOcdvZ4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022