UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hqL1uK5JUa0qt5fpLJwyh6Tx52oCryyjeT11Ot0NODE=' 
WHERE 
  key_id = '96b83d6524d4254d5ffd83dfc3b0d5dff7b8f1676ec24533d9d86aadd7be0723' 
  AND (
    token = 'hqL1uK5JUa0qt5fpLJwyh6Tx52oCryyjeT11Ot0NODE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031