UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MDG21xb07mOBOyd5s24/roz17B/mxk2pgWOMkYeKlpE=' 
WHERE 
  key_id = 'a04fdca39b02b004286b99ab046e1196a034002b830892bcf35df9e3affc17b1' 
  AND (
    token = 'MDG21xb07mOBOyd5s24/roz17B/mxk2pgWOMkYeKlpE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029