UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bMzX76OiwbEbBKzd0/ez6JPDrGo34GfJP3lsc08XoF0=' 
WHERE 
  key_id = '47c403728a6d957219939760b5e56a3e4e13a8e061312087fd37f920f3942b25' 
  AND (
    token = 'bMzX76OiwbEbBKzd0/ez6JPDrGo34GfJP3lsc08XoF0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029