UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6s/WQOp6q14lO1b2/y5iyXZPOuBCONkYjRRF8vsQl3g=' 
WHERE 
  key_id = '4c99bcdb2e193e264a8a193eddec03265b8c29a765fd566cc87e370a0d393f44' 
  AND (
    token = '6s/WQOp6q14lO1b2/y5iyXZPOuBCONkYjRRF8vsQl3g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045