UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'G7koA/3Y8U/Li+alJJg7CAgGKWAb7+nGZm2hg90+b1M=' 
WHERE 
  key_id = 'fe3652f611bce98618ca13e9f4f1d6843f798a5c47eb30779f48d8ecde844087' 
  AND (
    token = 'G7koA/3Y8U/Li+alJJg7CAgGKWAb7+nGZm2hg90+b1M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022