UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Gv0mQ739FB+XNAze0LEluPtNawtl5yryoiCXD1mscOw=' 
WHERE 
  key_id = '5d5d6de1702414713fbef1b4e23933e71d5e8247b95ff5ac50a3561a1bc5b0f5' 
  AND (
    token = 'Gv0mQ739FB+XNAze0LEluPtNawtl5yryoiCXD1mscOw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031